Statistics of items
Introduction
You can obtain an overview of item statistics at Purchase/Statistics/Statistics/Item. This functionality provides the statistics of each item purchased in terms of cost, margin, and other information which are displayed in the form of graph and data in Microsoft Excel.
Description
You can filter the items that you want to display by specifying one or more of the following criteria and clicking Start. The statistics of items that match the filter criteria you have specified are then displayed in Microsoft Excel.
Range section
Date
Type or select a range of dates to display the statistics of items within the selected date range. Select the All check box to display the statistics of items on all dates.
Note: Typing or selecting only the start date will display the statistics of items on the selected date and later dates. Typing or selecting only the end date will display the statistics of items on the selected date and earlier dates.
Item
Type or select an item to display the statistics for the selected item. Select the All check box to display the statistics for all items.
Fulfillment date
Type or select a range of fulfillment dates to display the statistics of items that were fulfilled within the selected date range. Select the All check box to display the statistics of items fulfilled on any date.
Note: Typing or selecting only the start date will display the statistics of items fulfilled on the selected date and later dates. Typing or selecting only the end date will display the statistics of items fulfilled on the selected date and earlier dates.
Purchase order
Type or select a purchase order or a range of purchase orders to display the statistics of items in the selected purchase order(s). Select the All check box to display the statistics of items in any purchase order.
Your ref.
Type or select a range of your reference numbers to display statistics of items for the selected your reference numbers. Select the All check box to display statistics of items for any your reference number.
Item group
Type or select an item group or a range of item groups to display the statistics of items belonging to the selected item group(s). Select the All check box to display the statistics of items belonging to any item group.
Warehouse
Type or select a warehouse to display the statistics of items belonging to the selected warehouse. Select the All check box to display the statistics of items belonging to any warehouse.
Ordered at
Type or select a supplier to display the statistics of items ordered from the selected supplier. Select the All check box to display the statistics of items ordered from any supplier.
Classification
Type or select a classification to display the statistics of items ordered from supplier(s) with the selected classification. Select the All check box to display the statistics of items ordered from supplier(s) with any classification.
Country
Type or select a country to display the statistics of items ordered from supplier(s) in the selected country. Select the All check box to display the statistics of items ordered from supplier(s) in any country.
Resource
Type or select a resource to display the statistics of items entered by the selected resource. Select the All check box to display the statistics of items entered by any resource in the purchase order line(s).
Cost center
Type or select a cost center to display the statistics of items entered by a resource belonging to the selected cost center. Select the All check box to display the statistics of item entered by a resource belonging to any cost center.
Assortments 1/2/3
Type or select the assortment(s) to display the statistics of items linked to the selected assortment(s).
Note: The Assortment boxes displayed depend on the number of assortments defined at System/General/Settings, under Item data settings or Purchase/Items/Assortments. For example, if three assortments are defined, three Assortment boxes will be displayed.
Options section
Show
Select Costs to display the statistics of items by costs, or select Quantity to display the statistics of items by quantity. If you select quantity, then the Unit option is available.
Unit
Select Purchase units or Sales units to display the statistics of items showing the quantities with the selected unit of measure.
Comparison
Select Current year to display the current year’s statistics of items or select Previous year to display the previous year’s statistics of items or select Planning to display the planning statistics of items.
Current year
This option is available if you have selected Current year for Comparison. Select one of the following to show more details:
- No — Select No to display the statistics of items without details
- Margin — Select Margin to display the statistics of items with margin details
- Discount — Select Discount to display the statistics of items with discount details
- Both — Select Both to display the statistics of items with both margin and discount details
Previous year
This option is available if you have selected Previous year for Comparison. Select one of the following:
- No — Select No to display the statistics of items without details
- Totals only — Select Totals only to display the statistics of items showing the totals
Planning
This option is available if you have selected Planning for Comparison. Select one of the following:
- No — Select No to display the statistics of items without details
- Totals only — Select Totals only to display the statistics of items showing totals. If you have selected Totals only, then the Budget scenario option is enabled
Budget scenario
Type or select a budget scenario to display the statistics of items showing the planning based on the selected budget scenario.
Top
Type a value to display the statistics of top items. For example, if you type 10, the statistics of top 10 items will be displayed.
Selection criteria
Select the Selection criteria check box to display the selection criteria in the statistics of items displayed in Microsoft Excel.
Include
Select All to include all details in the statistics of items. Select Item revenue to include only item revenue details in the statistics of items.
Buttons
Start
Click Start to generate and display the statistics of items based on the specified criteria in Microsoft Excel.
Advanced/Simple
Click Advanced for advanced filter criteria in the Range section will be available. The Option sections will also be made available. Click Simple for hide the advanced filter criteria.
Close
Click Close to exit
Related documents
Main Category: |
Attachments & notes |
Document Type: |
Online help main |
Category: |
|
Security level: |
All - 0 |
Sub category: |
|
Document ID: |
12.552.890 |
Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
Release: |
|
Attachment: |
|
Disclaimer |